April 17, 2008 at 2:47 am
Hi everybody,
I'm trying to import tables from as400 to sql server. I use DTS for that purpose.
The ODBC driver I use for AS400 access is "Client Access ODBC Driver (32-bit)".
The problem I'm facing is that the tables I'm importing have columns defined with CCSID = 280 (Italy) but they where entered with the code page of the session AS400=273 (Germany). Once I transferred this fields the german chars (ä,Ü.....) I see strange characters (é,]..) cause I see the CCSID=280 translation. Is it possible to tell SQLServer to read those field with a different CCSID (in this case 273) ??
thanks in advance for any help!!
Giuseppe Rigatti
April 17, 2008 at 4:48 am
Have you tried to set up German collation on columns you are interested in?
Piotr
...and your only reply is slàinte mhath
April 17, 2008 at 5:13 am
You can also view the data collating the column to the required one as follows -
select test collate German_Phonebook_CI_AS
from dbo.test1
Note: Check your relevant collation from the SQL Server collation list
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
April 17, 2008 at 6:00 am
when I try to change the column to German_Phonebook I've got the following error :
"Unable to modify table. ODBC error ... Incorrect syntax near 'COLLATE?".
What does that mean? And how can I check for the collation list of my server??
thanks you
April 17, 2008 at 6:22 am
Try the following syntax -
ALTER TABLE dbo.test1
ALTER COLUMN test VARCHAR(255) COLLATE German_Phonebook_CI_AS NULL
Note: There sould not be any dependent objects for the column......if exists, you need to drop them and recreate them after the alter.
You can find a select list for the database collations in the properties>options>collation of any database....other than this I don't have any idea for the availability of a list for the SQL Server collations......you can refer the standard CCSID (Coded Character Set Identifier), to have an idea of how to relate the CCSIDs with SQL Server Collations. Check out the following links -
http://en.wikipedia.org/wiki/CCSID
http://www-306.ibm.com/software/globalization/g11n-res.jsp
http://www-306.ibm.com/software/globalization/ccsid/ccsid_registered.jsp
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
April 17, 2008 at 6:50 am
still the same..
I was able to change the collation in German_PhoneBook but the result is the some.
I wonder if it's possible to change the collation when I read the data from AS400... I guess the problem stands there...
November 25, 2008 at 1:24 am
Hi All,
I am facing currently one problem.
While localizing software from english to german,i want to change the collation properties accordingly.
Another thing is dat,
i want to know that how csv (Comma Separated Value) file is maintained in German ?
As in English locale for CSV Purpose Comma is used ,because of which Data which is stoered in *.csv file when opens in excel sheet(By Default it opens in Excel only) all values which are separated by comma get stored in Different coloumn.
But there is different case in GErman Locale..!!
They used "," comma AS A SEPARATOR in number format (i.e 12.48=12,48 for german people.)
So when i want to take backup in csv format and if there is any data in number format then at that time all data get restorted as there appears 2 commas!!!!
eg 12.48,11.23 this will be stored as 12,48,11,23 in german locale which gives wrong result
i.e if lot no=12.48 and pos no=11.23 then in german locale it will be considerd as lot no =12 and pos no=48 remaining value will be garbage....!!!
So please help me out....
Thank YOu in Advance..............:)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply