Im running version 7.9 on msSQL. I was hosting my site on a English set server(US). I have set my SQL collation as Turkish, manually added Turkish Codepage directive on every page and the Turkish meta tags was inplace, as well as the Turkish LCID setting. I thought that I have totally configured my forum to work with Turkish characters and date/time settings. Never had a problem for the last 1.5 years.

 

Recently I have moved my site on a Turkish server. When I say Turkish server actually it is an English Windows Server with Turkish Regional Settings configured. Now the problems Im having is with the edited posts. Not the new posts that are being edit after the move, but the older posts that have been edited while on the English set server are returning Type mismatch: 'CDATE' error.

 

After following a few asp pages for debugging(with my poor programing knowledge), I guess I have figured out the problem. The time of the edit action is not directly kept on the database but it is attached to the end of the each post as a string. A function parses that string and convert it to the date/time format to display it. The numeric string Im talking about is a little allien to me since the string is something like "38371.8296759259" however it converts to date like "19.01.2005 19:54:44".

 

What I believe is the function(s) that writes and reads that string is somehow regional setting depended. Well honestly I must say that Im a little disapponted if it is regional settings depanded after all that CodePage and LCID settings configured. And since the US date format on the old server was MM/DD/YYYY and the new date format on my Turkish server is DD/MM/YYYY the function parses that string is messing up all of my previously edited posts.

 

...so what you think about my issue? What can be the best approach to solve the problem?

 

Thanks,

Halil