SQL Table Issue
Moderators: chulett, rschirm, roy
SQL Table Issue
Hi,
I am populating the SQL table from a hash file. For one column if there is a value it gets populated else a '?' appears in that column. I tried checking for space, null and even just with '' it still appears. Do anyone have an idea why SQL does this.
In the hash file this field appears blank if there is no value in it but in SQL table it appears as '?'
Any help is greatly appreciated.
Thanks
I am populating the SQL table from a hash file. For one column if there is a value it gets populated else a '?' appears in that column. I tried checking for space, null and even just with '' it still appears. Do anyone have an idea why SQL does this.
In the hash file this field appears blank if there is no value in it but in SQL table it appears as '?'
Any help is greatly appreciated.
Thanks
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
What is your database?
DB2, for example, allows default values for columns to be set at the database.
What tool are you using to see the "?" in the columns?
DB2, for example, allows default values for columns to be set at the database.
What tool are you using to see the "?" in the columns?
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
When you look at the data in your hash file, what value is in the column?
What is its data type?
What is its data type?
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
I had this problem once, where nulls in the hash file (I think the in one of the key fields) were "converted" to an odd character. I ended up testing for the value that was in the field and converting it to null on the output. I think it was Char(254) or Char(253), but I can't remember.
Good Luck,
Tony
Good Luck,
Tony
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
I doubt if this is the issue, but...
If you login to Administrator, click on the project and click on the Properties button, you should see an NLS tab if you have NLS enabled on the server.
If NLS is enabled, the NLS tab should show the default character set for the project. It's possible that you have one character set and your database is using another....
Tony
If you login to Administrator, click on the project and click on the Properties button, you should see an NLS tab if you have NLS enabled on the server.
If NLS is enabled, the NLS tab should show the default character set for the project. It's possible that you have one character set and your database is using another....
Tony
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA