Player name query

Debate directly related to English Chess Federation matters.
Post Reply
User avatar
John Upham
Posts: 7179
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Player name query

Post by John Upham » Thu Dec 28, 2017 12:35 pm

Does anyone know the correct name for a payer listed as

de La Motte de Bro�ns de Vauvert, Sa�k

whose ECF grading code is 309787A from Oxford City Chess Club ?

This record in the ECF membership list is causing an import process to barf when attempting to import the ECF membership list into the various LMS systems I manage.

The record is on line 2292 of today's membership list.
British Chess News : britishchessnews.com
Twitter: @BritishChess
Facebook: facebook.com/groups/britishchess :D

Mike Truran
Posts: 2393
Joined: Wed Apr 11, 2007 3:44 pm
Contact:

Re: Player name query

Post by Mike Truran » Thu Dec 28, 2017 12:59 pm

He is shown as de La Motte, Saik on the OCA database.

User avatar
Matthew Carr
Posts: 144
Joined: Tue Jun 14, 2011 2:19 pm

Re: Player name query

Post by Matthew Carr » Thu Dec 28, 2017 1:33 pm

What is your LMS software using? ASCII or UNICODE or something else?

User avatar
John Upham
Posts: 7179
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: Player name query

Post by John Upham » Thu Dec 28, 2017 2:17 pm

Matthew Carr wrote:
Thu Dec 28, 2017 1:33 pm
What is your LMS software using? ASCII or UNICODE or something else?

The back-end databases uses MySQL as their engine.

I download the Membership List, remove the first record / header and then export CSV format.

This is then imported into the MySQL db via the phpMyAdmin GUI.

The default character set (I suspect this is what you are asking) is utf-8.
British Chess News : britishchessnews.com
Twitter: @BritishChess
Facebook: facebook.com/groups/britishchess :D

Richard Thursby
Posts: 285
Joined: Wed Feb 25, 2009 11:25 am
Location: origin + pathname + search + hash

Re: Player name query

Post by Richard Thursby » Thu Dec 28, 2017 3:10 pm


Richard James
Posts: 1175
Joined: Tue Apr 17, 2007 7:34 pm
Location: Twickenham
Contact:

Re: Player name query

Post by Richard James » Fri Dec 29, 2017 10:56 am

Diaereses seem to be an issue.

I used to have a problem uploading the master database into UTU because of a player with the first name Gaël, but his name has now been changed to Gael. It looks like the bug has been partially corrected in the current version of UTU: Dr de la Motte was accepted last time I uploaded but the letters with diaereses were replaced with question marks.

I presume he's related to this French bishop.

Post Reply