That do you think about additional table with set of strings for each parent
object?
My idea is to split very long string to set of varchars with acceptable for
your database length.
C> ...? Varchar datatypes are usually not long enough. In particular,
C> I'm working with mysql but if there are no solutions for mysql then
C> just out of curiosity's sake I was wondering what is done in these
C> cases. Any help would be greatly appreciated!
Igor Shekalev, www.sqledit.com - powerful database tools
Re: escaping vs stored procedure ... it's really (PHP's MySQL library)'s function? ... It is a library function in MySQL. ... ng that mysql_escape_string prevents sql injection.... mysql_real_escape_stringstrings,... (comp.lang.php)
Re: import txt file to mysql with ruby & load data local ?? ... Yes, if it will work with MySQL directly, it should work here as well. ... If you have valid MySQL strings, strings that created what you expected from ... are your valid strings will work with Ruby's MySQL interface.... (comp.lang.ruby)
Re: Strip slashes? ... Also, manipulating strings... with slashes in PHP is a pain the arse ... when inserting into MySQL. ... (alt.php)
Re: important problem with mysql and a service java ... in your SQL syntax; check the manual that corresponds to your MySQL... The correct solution is to give each user a unique ID number using a column which is declared with the "auto_increment" qualifier, then store the strings in another table, linked to the user through his ID number. ...userid integer auto_increment primary key ... (comp.lang.java.databases)
Re: Getting UTF-8 strings from MySQL ... >I'm having problems retrieving strings from MySQL in UTF-8.... when I retrieve the strings they are not formatted correctly. ... (comp.lang.java.databases)
