codepage conversion - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

codepage conversion

Author

Topic

nnmmss
Starting Member

3 Posts

Posted - 2005-07-30 : 05:48:09

I have data in access which want to import them into the sql, but the data in access are in utf-8 codepage and i want to they converted to windows-1256 into sql , how can i do this conversion/

Kristen
Test

22859 Posts

Posted - 2005-07-30 : 06:22:36

I *think* if you create your table in SQL with the appropriate COLLATE specified on every char/varchar/text column when you do the import from Access (i.e. using DTS) the data will be converted to the target column's collation.

If you just do
INSERT INTO TargetTable
SELECT *
FROM SourceTable

that might NOT be the case [but I haven't tried it], in which case I would be inclined to do


INSERT INTO TargetTable
SELECT MyColA COLLATE xxx,
       MyColB COLLATE xxx,
       ...
FROM SourceTable

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources