Cannot insert a semi-colon as a string value
Posted by: James Cronin
Date: October 21, 2004 11:41AM

I switched from the ByteFX .NET connector to the MySQL .NET connector recently, and I too have noticed some inconsistancies, and wierd things occurring. Namely, I cannot insert a record when a the value contains a semi-colon.

Background on my discovery: I am tracking user activity within my application, and in doing so, I save the HttpContext.Current.Request.UserAgent (info on browser, platform etc). The following value, when attempting to insert, produces errors:

`Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)`

I then stripped the semi-colons from the string, and the insert worked just fine. Just a little tip for those who might be experiencing the same.

Idea Jar Technologies

Options: ReplyQuote

Written By
Cannot insert a semi-colon as a string value
October 21, 2004 11:41AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.