Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am using SYBASE ASE 16.0 and in my tables i have some values like
"KOCAELİ", "İZMİR", "TALATPAŞA"
. They are readable in csv file however when i put database with bcp in command, i have mistakes which are
"KOCAEL0", "0ZM0R", "TALATPA^A
my command is :
bcp ME_DEV_TRUNK_DB..aktar2 in list.csv -b10000 -c -t',' -r\\n -Usa -SMYDB1 -Jiso88599 -F2
How can i fix and input data into database?
bcphas completed, and have you made sure that tool is using the correct character set (ie, have you verified the issue is not with your viewing tool as instead of the database)?isqlthat comes with ASE) display the characters correctly when configured to use iso88599?