|
Home > Archive > SQL Anywhere database > October 2005 > UNLOAD LOAD Problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
UNLOAD LOAD Problem
|
|
| Peter Stojkovic 2005-10-27, 7:40 am |
| ASA 9.02 Build 3124
I have the following Problem:
Existing database
Charset is : 1252LATIN1
I make an UNLOAD with SYBASE-Central with the complete database including
data.
In same table are columns char(128) with special german characters like öäü
I generate a new database with charset UTF8.
When I try to load the exported data with LOAD , it will generate errors,
when one special row is loaded.
because the special charakter are now interpreted as ( i am not shure )
delimter or something else.
That means, everything behind special character is missing ( NULL-values )
[for the following columns] or sometimes the special character is
interpreted like Carrige return ( CR ),
..
What is the correct way to do the conversion from : 1252LATIN1 to UTF8
without looosing data , if there are special characters inside
like german öäü ??
Thanks for your help
Peter Stojkovic
| |
| John Smirnios 2005-10-27, 7:40 am |
| See http://www.sybase.com/detail?id=1034325
-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
Peter Stojkovic wrote:
> ASA 9.02 Build 3124
>
>
> I have the following Problem:
> Existing database
> Charset is : 1252LATIN1
> I make an UNLOAD with SYBASE-Central with the complete database including
> data.
>
> In same table are columns char(128) with special german characters like öäü
>
>
> I generate a new database with charset UTF8.
>
> When I try to load the exported data with LOAD , it will generate errors,
> when one special row is loaded.
> because the special charakter are now interpreted as ( i am not shure )
> delimter or something else.
> That means, everything behind special character is missing ( NULL-values )
> [for the following columns] or sometimes the special character is
> interpreted like Carrige return ( CR ),
> .
>
> What is the correct way to do the conversion from : 1252LATIN1 to UTF8
> without looosing data , if there are special characters inside
> like german öäü ??
>
> Thanks for your help
> Peter Stojkovic
>
>
>
>
>
>
>
|
|
|
|
|