Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davemere
Starting Member
4 Posts |
 Posted - 2007-11-02 : 11:55:07
|
Hi there. I'm trying to create a copy of a remote database for development purposes. I am useing MySQL, the remote database is in MSSQL. The create table commands contain a collation titledquote:
SQL_Latin1_General_CP1_CI_AS
which MySQL doesn't recognise. The three most similar collations I can find in MySQL are:quote:
'latin1_general_ci','latin2_general_ci''latin7_general_ci'
Does anyone know the difference between these collations? And whether any of them is equivalent to the MSSQL code I have to implement?thanks! Dave |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-02 : 12:28:13
|
| SQL_Latin1_General_CP1_CI_AS means the Latin alphabet, ISO code page 1252, Case insensitive and Accent sensitive. after some googling it appears latin1_general_ci is the latin alphabet, codepage 1252, case insensitive and by default accent sensitive.links of interest...http://dev.mysql.com/doc/refman/5.0/en/charset-we-sets.htmlhttp://help.scibit.com/mysql/manual_Charset.html |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-02 : 22:21:39
|
| By the way, you can script the db without collation. |
|
|
|
davemere
Starting Member
4 Posts |
Posted - 2007-11-08 : 11:30:22
|
| Mmm yeah I thought about it. Wouldn't that be asking for trouble down the line though? I'd prefer to get the db set up and stable before proceeding with development |
|
|
|
|
|
|
collations