Character Set

Character Set

Postby 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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Fri 02 Apr 2010 10:47

I have moved the topic to the dotConnect for MySQL forum.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby 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.
Shalex
Devart Team
 
Posts: 7340
Joined: Thu 14 Aug 2008 12:44

Postby 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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby 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'")
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL