Data Loading using Spanish characters -
08-04-2004
, 10:41 PM
Currently we are using Sybase 12 and a Pogo wrapper to load data into
Sybase databased. But recently there has been a requirement to handle
special characters(spanish like Kéñ etc). But for some reason Pogo
does'nt like those and eventually fails during load process. It pretty
much interprets the special characters as K\351\361 and since there is
a difference in the row lengths it fails.
Does anybody have come accross such issues involving Sybase with Pogo.
Can this be done using normal BCP. I did give it a try but was'nt
sure if I should include any localization options like the character
set etc.. And if this needs to be implemented should there be a server
level change to install a new character set etc ???
Appreciate if you can provide me with some pointers.
-Ben |