Rank: Newbie
Groups: Registered
Joined: 10/26/2019(UTC) Posts: 9  Location: China Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
|
Hi,
I am now using Seal report to connect to Oracle DB. But the output contains Chinese character. All these show as ???. I assume it's related to coding. But how can I change the coding for Seal report?
Thanks,
John
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Seal Report is an unicode application and should support chinese and arabic.... In made a small report to show that it works  test chinese arabic.srex (3kb) downloaded 3 time(s).Are you sure of your Oracle driver ?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/26/2019(UTC) Posts: 9 Location: China Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/26/2019(UTC) Posts: 9 Location: China Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
|
I am using instantclient-basic-windows.x64-12.2.0.1.0 and instantclient-odbc-windows.x64-12.2.0.1.0-2. Created a System DSN. Then use OLEDB ODBC in Seal report. Is that OK?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Perhaps you should use the native OLEDB Oracle driver instead of OLEDB over ODBC, sorry we do not have experience with unicode with Oracle.... Is is a more general question: OLE DB Oracle unicode support, you can search the internet Edited by user Friday, November 8, 2019 10:36:22 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/26/2019(UTC) Posts: 9 Location: China Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
|
Thanks buddy.
I have found the solution. So post the steps here. Hope someone else can benefit from my case.
1. When create DSN, check 'Froce SQL_WCHAR support' under 'Workrounds'
2. Run [select userenv('language') from dual] by using any Oracle client and note the output
3. Create a system variables 'NLS_LANG' and set the value as the SQL's output
4. Restart system and recreate data source in Seal Report
|
 1 user thanked JohnChen for this useful post.
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
