G
Garry Hall
Guest
This is probably a misconfiguration or misunderstanding of codepages. There are many things at play here: the codepage of the database (if extracting from a db), the -cpinternal of the client session, the -cpstream of the client session, and any CONVERT TARGET on your OUTPUT statement . There is also the charset handling of the editor you are using to view the output. One suggestion: run your client with -cpinternal = -cpstream = db codepage, so there is no conversion done, and EXPORT the same string. The bytes you see in the output will be the bytes that are stored in the db. Look at it with a hex editor, or od, to see what the bytes are. If they do not reflect the chars you expect to see, this data might be corrupted in the database.
Continue reading...
Continue reading...