Page 1 of 1
Character Set
Posted: Thu 01 Apr 2010 12:44
by Zero-G.
Hey
I have to use latin1_german1_ci as character set from client side. - But this is not supported in your list. - I just can use latin1
Is there any information about this?
THX
Posted: Fri 02 Apr 2010 10:47
by AndreyR
I have moved the topic to the dotConnect for MySQL forum.
Posted: Fri 02 Apr 2010 13:08
by Zero-G.
Thank you
OK, I made a litte mistake!
The character set "latin1" is correct. - But what seems to be a problem is the collation character. - This I can't set explicit. - I need "latin1_german1_ci" and this I can't set.
THX
Posted: Fri 02 Apr 2010 13:36
by Shalex
There is no particular property for collation. Please set the collation for the current session by executing the SQL statement via the command.
Posted: Fri 02 Apr 2010 13:47
by Zero-G.
Hey
Here is the problem @all (and that was the reason for the Linq forum...)
In LinQ I can't set this by code!
THX
Posted: Fri 02 Apr 2010 14:08
by AndreyR
You can. Just call the ExecuteCommand method:
Code: Select all
dataContext.ExecuteCommand("SET NAMES 'latin1' COLLATE 'latin1_german2_ci'")