Unicode Problem with ORACLE

General discussion forum about all databases other than SqlBase.
ethanasi
Albania
Posts: 52
Joined: 01 Jun 2020, 14:32
Location: Albania

Unicode Problem with ORACLE

Post by ethanasi » 04 Jun 2008, 12:29

I am having this problem with ORACLE database.
I can insert with TD51 words containing "ë", but when I try to select I get:

"Unicode conversion failed."

What am I doing wrong?

Also, in design time, I cannot insert "ë" with ALT-137.
Instead, I can paste "ë" from notepad.

Thanks

Jean-Marc Gemperle

Re: Unicode Problem with ORACLE

Post by Jean-Marc Gemperle » 04 Jun 2008, 14:13

Hi,

I assume you use the SP3...isn't it, still we like you to confirm because you should not see those in TD 5.1 SP3...
Also you don't mention if you insert fetch via SQLTALK, there still might be a problem with SQLTALK.
Also need to know the data types beeing used.
The oracle instance char set is important to know and the ORACLE version as well.

So I did the test an use the following
1)Oracle 11g but I know this runs on 10g fine to
2)ORACLE instance is default 1252, the NLS_LNAG does not matter anymore since TD 5.1SP2
3)using VARCHAR2(2000) I can insert 2000 row with concatenation of your special char as well as selecting it back and verify the end of thse string contains the char

Note that there is issue with table window not related to that, just see the insert/fetch issue. The table window issue is
TD-4692
ORACLE VARCHAR2(2000) Inserting/fetching is OK, but SalTblPopulate() returns ncorrect results in a popu edit

----ALSO with OLEDB this testcase worked fine couple weeks ago but now I have an unrelated issue with oledb :roll:

Also I think the issue of using key combination ALT to enter something in a data field is a problem with TD.. See the forum I guess Mike answered on this. Could you please create a new THREAD basically one per problem :-) it helps us to keep track of the issues...

So I cant repro your issue with the details given. Please modify the testcase to show it to us and always give much details please.

JM
You do not have the required permissions to view the files attached to this post.

ethanasi
Albania
Posts: 52
Joined: 01 Jun 2020, 14:32
Location: Albania

Re: Unicode Problem with ORACLE

Post by ethanasi » 05 Jun 2008, 06:39

Sorry!
Should have described better my environment.
TD51 SP2
Oracle 9iR2 WE8MSWIN1252
Not using OLEDB
And, I can insert from TD51 app in ORACLE, but I cannot select in the same app.
I tested selection with SQLTalk, and it works OK.

I will install SP3 and let you know the results.

Thanks!

ethanasi
Albania
Posts: 52
Joined: 01 Jun 2020, 14:32
Location: Albania

Re: Unicode Problem with ORACLE

Post by ethanasi » 05 Jun 2008, 07:19

Installed sp3.
And it works. "ë" is selected OK from database.

Still remains the problem that I cannot insert "ë" using ALT-137 like I did here.
And, after applying SP3, the buttons, and appearance in general has all changed. It seems that they are not using skin anymore.

I will check if this is reported before, and whether there is a solution for this.

ethanasi
Albania
Posts: 52
Joined: 01 Jun 2020, 14:32
Location: Albania

Re: Unicode Problem with ORACLE

Post by ethanasi » 05 Jun 2008, 08:19

OK!
Problems with the skin solved after a new installation of TD51 and SP3.
Apparently, there was a problem during SP3 installation.

Still remains, though, the problem with ALT-137.

Thanks

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest