| conversion problems [message #663929] |
Mon, 26 June 2017 09:14  |
 |
banach600
Messages: 14
Registered: June 2017
|
Junior Member |
|
|
Hi all,
In a project, I am led to select data in oracle database (distant server) and then inject them into a mysql database (local machine with Ubuntu 16). In the oracle database, we have data in French and Arabic, with the following parameters:
NLS_LANGUAGE FRENCH
NLS_TERRITORY FRANCE
NLS_CURRENCY ?
NLS_ISO_CURRENCY FRANCE
NLS_NUMERIC_CHARACTERS ,.
NLS_CHARACTERSET WE8ISO8859P9
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/YY
NLS_DATE_LANGUAGE FRENCH
NLS_SORT FRENCH
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.4.0
In the local machine, when I use UTF8, the accented characters are displayed correctly, unlike the Arabic characters (ÏÈáæã). I also tested AMERICAN_AMERICA.WE8ISO8859P9, then there all the data are displayed correctly in the navigator (modulo the change of encoding in windows-1256). On the other hand, when I start inserting this data in mysql, I receive this error:
SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF4me EN...' for column 'lic_dip' at row 1
Thank to anyone who can enlighten me on this problem.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
