Subject | About COLLATE conversion from MSSQL.... |
---|---|
Author | Rasmus Olesen |
Post date | 2004-07-09T14:32:16Z |
Hi
I'm converting a large DB from MSSQL2k --> FB1.5Final and i'm having
some trouble grasping these COLLATE's that my former colleagues put
on their MSSQL tables : (example column)
...,Name varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,...
From what i got from the MSSQL docs, this means that the up to 50
chars in this field, can be only Latin1 chars of Codepage 1252(=CP1)
and in any case(=CI) and that this Collation should be the default
one.
In Firebird 1.5, is it also the case that it is the default, if i
haven't tampered with the serverside settings and how do i check
which one is the default Collation ?
If i should need to explicitly specify every collation like this
one, should i then use :
...,Name varchar (50) character set WIN1252 collate WIN1252,...
or
...,Name varchar (50) character set ISO8859_1collate ISO8859_1,...
??
tia.
/Rasmus
I'm converting a large DB from MSSQL2k --> FB1.5Final and i'm having
some trouble grasping these COLLATE's that my former colleagues put
on their MSSQL tables : (example column)
...,Name varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,...
From what i got from the MSSQL docs, this means that the up to 50
chars in this field, can be only Latin1 chars of Codepage 1252(=CP1)
and in any case(=CI) and that this Collation should be the default
one.
In Firebird 1.5, is it also the case that it is the default, if i
haven't tampered with the serverside settings and how do i check
which one is the default Collation ?
If i should need to explicitly specify every collation like this
one, should i then use :
...,Name varchar (50) character set WIN1252 collate WIN1252,...
or
...,Name varchar (50) character set ISO8859_1collate ISO8859_1,...
??
tia.
/Rasmus