ansaurus

Question

Strings are appended with special characters when returned from the database

Answer 1

+4 A:

CHAR(20) means the field is padded as necessary to be exactly 20 characters long. The padding character is a blank.

There must be a problem somewhere in your character set settings if padding characters appear as question marks. You may find more insight on your problem here.

What you need here is to trim the returned strings, or better yet move to VARCHAR2(20).

Mac 2009-08-21 09:55:16

Yes that's right. I generally stick to VARCHAR unless I know that something is fixed length like a 3 character currency code.

pjp 2009-08-21 09:56:54

Is this the only solution? It'd be quite painful to trim all the strings before usage specially with databinding.

Ali Kazmi 2009-08-21 09:58:16

Nope. Unless you can have your own queries and add TRIM on every CHAR field. VARCHAR2 is really the type you wanted there, not CHAR.

Mac 2009-08-21 10:05:28

I just queried the database directly through ADO.NET (OleDbConnection) and it works perfectly. No special characters at the end. Why??? :(

Ali Kazmi 2009-08-21 10:32:08

Answer 2

A:

Hi,

I couldn't find a proper solution for this issue but changing the nhibernate driver from 'OracleClientDriver' to 'OleDbDriver' solved this issue. Still if anyone knows how to tackle this issue properly please let me know as I don't like using the OldDbDriver for accessing Oracle because of possible compatibility issues.

Ali Kazmi 2009-08-21 12:34:11

Well, I'm pretty sure you are still having your strings padded, but with real blanks instead of invalid characters.

Mac 2009-08-21 13:35:17

ansaurus

tags:

views:

answers:

Strings are appended with special characters when returned from the database

related questions