Character Set

Zero-G. · Post by **Zero-G.** » Thu 01 Apr 2010 12:44

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

AndreyR · Post by **AndreyR** » Fri 02 Apr 2010 10:47

I have moved the topic to the dotConnect for MySQL forum.

Zero-G. · Post by **Zero-G.** » Fri 02 Apr 2010 13:08

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

Shalex · Post by **Shalex** » Fri 02 Apr 2010 13:36

There is no particular property for collation. Please set the collation for the current session by executing the SQL statement via the command.

Zero-G. · Post by **Zero-G.** » Fri 02 Apr 2010 13:47

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

AndreyR · Post by **AndreyR** » Fri 02 Apr 2010 14:08

You can. Just call the ExecuteCommand method:

Code: Select all

dataContext.ExecuteCommand("SET NAMES 'latin1' COLLATE 'latin1_german2_ci'")