ilMes mes wrote: > > if i use LONG ASCII, it work fine with: > insert into tableName (long_field) VALUES (x'10203d') > > If i create a table width a column LONG BYTE, > i do not understand the way to insert a record. > I try: > insert into tableName (long_field) VALUES (x'10203d') > but no not work. >
Ok, for short LONG BYTE column there should be a way to insert a string literal as can be done for LONG ASCII. I will check this. But on the other hand, using a string-literal to insert into a LONG (which may be up to 2GB) is very uncommon. Usually parameter are used INSERT ... VALUES (:param) and depending on the interface you are using, a variable is bound to this parameter and the client-tool will send the value of the bound parameter to the server, even if it exceeds the length you could specify in a string literal. Check the archive for this topic/the description of the client tool / interface you are using how to bind variables. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
