Recent content by benthicsoftware

Hi Marco, As mentioned, the code in question is the QueryGrid demo from the DOA install. I see that the unicode characters in my query got converted in the html. It's just a test query of dual with a number of greek unicode characters in a string literal. I can query the same string from a...

Hi Marco, I'm a bit confused on Unicode support in DOA 4.1.2. It looks like it always brings data as utf8 (if that's the databases character set) and then converts it to utf16 on the client. Is there a way to set the session to use utf16 by default? Usually this is done using OCI_UTF16 in...

Hi Marco, Fantastic, Thanks! -Mark

Hi Folks! I know that I need the 32bit client for my DOA apps to work, but what do you do on a 64bit Oracle server and want to run the apps on the server itself? I assume you need to install the 32bit client, but won't that cause issues with the server dlls? Thanks for any information! -Mark

I may be wrong about this but wouldn't that change make it so that the DB unit would always have to be included in DOA apps? I actually like the ability (using the NODATASET define) to remove DB if we don't use it. Perhaps not a big issue but something to consider.

Make sure you try the same query in SQLPlus to see if it is an Oracle issue. I know that a query with a LONG column will cause what you are seeing when using an Oracle 9 client and an 8.1 server where the character set is unicode. -Mark Ford Benthic Software

True! Congrats to Marco and Allround for getting the beta out Thursday! -Mark Ford Benthic Software

Oracle 6? Does DOA even work with that version?

You just need to double up single quotes inside literal strings in SQL. So for example 'Dave's Diner' should be 'Dave''s Diner'. You only have to do this for string literals, not for binds variables and such. -Mark Ford Benthic Software

Hi Marco, Thanks. I have done some research and managed to rewrite InternalDescribe and InternalDefine to handle nchar types as unicode (a few other changes were needed as well.) It seems to work so far! -Mark

I get a single byte chr(191). This is the actual data in the buf field of the TFieldData object in the FieldByIndex call. Does it work for you? Does DOA support nchar/nvarchar types? Thanks, -Mark

Hi Marco, I want to run the following query: select nchr(1513) from dual; under Oracle 9i and get back a unicode character (it's a hebrew character that looks like a styleized 'W' that I'm using for testing.) I can't seem to get this back using DOA (I'm using some Unicode aware controls and...

SQLPlus brings everything back as strings and so avoids rounding. The setting to do this for all data in DOA is something like StringFieldsOnly (not positive on that name, you'll have to look it up.) You could also use to_char() on just that field. -Mark

Hi Marco, Just a quick question on this. I do it to all my installations and it definitely helps enormously. I've been hesitant to recommend it to all of my customers because I assume that someone must need the NTS setting. Do you have any idea why that setting is the default and who needs...

I don't know if it helps you, but note that in 8i and above you can force the ROWNUM pseudocolumn to be in order even if there is an order by clause by putting the query with the order by into an 'inline view'. A quick example is: select rownum, t.* from (select * from emp order by ename) t; I...