Datetyp for text

A

Arun Wadhawan

Hello

I would like to insert from a Form text to SQL Table. It works fine, but
only with special signs like apostroph, german signs it doesn't work. The
error message is each time :


Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
' >>( speacial sign ) >>


How can I manage this generally, I would also need to insert some kyrillic
letters over this form to the SQL Table.

Can I change the Datetyp on the SQL Server of the table ?
Some other methods ?
Thanks a lot
Arun
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Connection Error with MS Access 7
Parameters, Passthrough UpdateQueries, and SQL 7
Slow response from MS access report 3
Modern equivalent of Autotext in Word? 0
SQL Server not recognizing aliased table 3
How do I get rid of strange special characters? 3
TransferSpreadsheet method question 2
ODBC Update on a linked table 'table name' failed 1

Top