logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
JohnChen  
#1 Posted : Thursday, November 7, 2019 2:40:02 AM(UTC)
JohnChen

Rank: Newbie

Groups: Registered
Joined: 10/26/2019(UTC)
Posts: 9
China
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
epf  
#2 Posted : Thursday, November 7, 2019 7:57:53 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

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 ?
JohnChen  
#3 Posted : Friday, November 8, 2019 2:54:48 AM(UTC)
JohnChen

Rank: Newbie

Groups: Registered
Joined: 10/26/2019(UTC)
Posts: 9
China
Location: China

Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
Thanks for your reply.

Please take a look at the screenshot attached. Top one is Seal report. Bottom one is PLSQL client output.

https://drive.google.com...hD5FaJwcVRCzZd1MP-KdjcTK

Edited by user Friday, November 8, 2019 2:55:46 AM(UTC)  | Reason: Not specified

epf  
#4 Posted : Friday, November 8, 2019 6:59:45 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Yes but PL/SQL will not use the same driver as Seal Report...
Did you use the Oracle driver (ODAC): https://www.oracle.com/d...gies/odac-downloads.html ?
Perhaps it is specific for unicode characters.

JohnChen  
#5 Posted : Friday, November 8, 2019 8:55:58 AM(UTC)
JohnChen

Rank: Newbie

Groups: Registered
Joined: 10/26/2019(UTC)
Posts: 9
China
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?
epf  
#6 Posted : Friday, November 8, 2019 10:35:01 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

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

JohnChen  
#7 Posted : Sunday, November 10, 2019 12:48:18 PM(UTC)
JohnChen

Rank: Newbie

Groups: Registered
Joined: 10/26/2019(UTC)
Posts: 9
China
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
thanks 1 user thanked JohnChen for this useful post.
epf on 11/11/2019(UTC)
Users browsing this topic
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.