September 8, 2009 at 11:01 am
Hi all:
Here is my problem:
Converting DB2 databases (AIX) to SQL Server 2008. Had to adjust the collation to case sensitive so it wont give me duplicates in the data. BUT now the queries also require to be upper case otherwise it gives unknown column name.
How can I change the case sensitive IN the data ONLY and not on the table and column names?.
I know I can set the collation by column name, but that is a lot of work to change collation on all 321 tables.
Any help please?
Thanks
September 8, 2009 at 11:35 am
I don't have DB2 experience, but I'll give it a try...
I think, if collation is an issue for table and column names, you should consider renaming them into names only using characters in the range of [a-z,A-Z,0-9,_]. For readability it means a lot if your column names aren't all upper case also (I like ProductCode a lot better than PRODUCTCODE for example), so you probably want to prevent that. I think you should fix your (meta)data first before you start converting.
If you want a better answer, you should provide some debug results and examples.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply