Oh Eirikur Eiriksson, i am impressed by your script :w00t:

In your sample, you are listing the colums of the table to audit and if this table changed (column added or...

Ok, I understand SQL Kiwi. I'll make insert statements and post them after.

Thank you 😉

Hi 🙂

Thank you Lowell and SQL Kiwi for your answers.

Our application send SQL requests one-by-one via ODBC cursor and then fetch next. With the good collation, SQL would return...

Thank you Lowell for your answer :-).

I tried what you said:

Database Collation CI_AI with a select column collate with a collation BIN.

More explanations:

With my select ordered by column...

Finally, it was about code pages and ODBC driver.

different code pages (client and sql server). I have to change the default collation of the server and recreate the database.

Thanks 🙂

Thanks 🙂

I think, I do not have choice of using cursors when accessing SQL Server by ODBC functions.

I use SQLSetStmtAttr(Statement with SQL_ATTR_CURSOR_TYPE attribute).

Application in C-­->ODBC functions (thats implements cursors)->SQL...