question

Chaoqing X avatar image
0 Likes"
Chaoqing X asked tannerp commented

Chinese character mess up when write data to Oracle database

the chinese character mess up when write data to Oracle database from flexsim by odbc. but the english character is ok. the problem is shown in the picture.

We tried many methods and failed to solve the problem,but there are some tips:

1/ the Oracle database can successfully write Chinese character by other tool,such as sqlplus OR navicat.

2/ we also have changed the encoding method of oracle database to utf-8, but the Chinese character still mess up when write data to Oracle DB by ODBC or dbconnnector of flexsim.

FlexSim 18.2.3
flexsim 18.2.3oraclechinese characterodbc error-flexsim code 17
1590110311.jpg (190.7 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Xu Chunqi avatar image
2 Likes"
Xu Chunqi answered tannerp commented

Dear Chaoqiong, we suggest that you searches how to solve the messed chinese character when writing into Oracle database firstly.

· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

tannerp avatar image tannerp commented ·

I will second @Shiny Xu's suggestion. When you export the Chinese characters from FlexSim - not into an Oracle database, but rather a regular export - do they export correctly?

It sounds like the error is on the Oracle DB end, although it's possible that FlexSim is partly responsible, in which case we would want more information about the method you're using to export the data.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.