Print Thread
expecting: string actual: widestring
#44410 08/15/12 09:13 AM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
Hi,

we recently upgraded to the latest DOA version. In one of our applications we link to a view that reads data from an other database.

In the older verion this worked ok. In the new version we get the error: expecting: string actual: widestring on a varchar2 field.

Is there a way to force this dataset to stringfields in stead of widestring. (Like it used to work?)

kind regards

Ruud

Re: expecting: string actual: widestring
Ruudbern #44411 08/15/12 10:19 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
Is this a Unicode database? If so, you can set Oracle.NoUnicodeSupport to True to force Unicode data conversion to the local character set. This way you omit the widestring fields.


Marco Kalter
Allround Automations
Re: expecting: string actual: widestring
Marco Kalter #47643 08/06/13 08:09 AM
Joined: Oct 2000
Posts: 8
Kristiansand, Norway
O
Member
Offline
Member
O
Joined: Oct 2000
Posts: 8
Kristiansand, Norway
I have the same problem. Where do I set Oracle.NoUnicodeSupport to True?

Re: expecting: string actual: widestring
Ole Petter #47644 08/06/13 08:45 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
At run-time during initialization of your application.


Marco Kalter
Allround Automations
Re: expecting: string actual: widestring
Marco Kalter #47658 08/07/13 07:46 AM
Joined: Oct 2000
Posts: 8
Kristiansand, Norway
O
Member
Offline
Member
O
Joined: Oct 2000
Posts: 8
Kristiansand, Norway
Thanks. That worked it out

Re: expecting: string actual: widestring
Marco Kalter #48845 04/01/14 11:48 AM
Joined: May 2005
Posts: 30
Member
Offline
Member
Joined: May 2005
Posts: 30
Hello.

I would like to use this topic to know more about the DOA conversion by setting NoUnicodeSupport. I made a short test with a english and portuguese version of Windows, both seems to work with our common characters with accent.

There is a single mapping for all western languages? I'm specifically interested in english, spanish and portuguese.

With the Oracle XE 11.2, there is a fixed charset of AL32UTF8, so this is the only reason at the moment to deal with Unicode. I could be using ForceWideStringFields and changing all the TStringField - but with many hundred of thousands lines of code, it doesn't worth right now

Last edited by Tailor K; 04/01/14 11:50 AM.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 15 (0.006s) Memory: 2.5178 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-03-28 10:17:32 UTC
Valid HTML 5 and Valid CSS