How to insert image into MS SQL 2000?

[Anon]

I had saw some code to insert and select image using php4 and mysql. I use almost the same method to insert image to MS SQL2000.
The image size is 128KB. But i just get the message like below. about 20 lines:

Warning: MS SQL message: The identifier that starts with 'A?œ¸y?~%à²?Àbs\\l?PÊò¼\"S?áòìf/?(ÅÎ\\=\\Ei9m ÙòB1_èg‹^à|?×Áâ}ŸöÆy‰È??œ\\g‰«ý¹—BšWJQÃR? -;.JP„¦¥^*j?Õ\"Šþ?½û%6' is too long. Maximum length is 128. (severity 15) in D:\Inetpub\wwwroot\cgi-bin\insertimg.php on line 6

anybody have some idea?

[Anon]

The way I have found to be most reliable is to base64_encode your image then insert that into a text field in your table.
Make sure you pump up the following values in your php.ini and restart IIS
mssql.textlimit = 2147483647
mssql.textsize = 2147483647

when you want to view it.. select the data, base64_decode the variable storing the data. perform a stripslashes on it and you should have exactly what you started with.. try not to go over about a 1 meg or so with this format.

Hope this helps.