Carter: Snoyes: But i use INSERT INTO SELECT, where will the actual values go?Do you have any examples of thatr?
Bachinski: Jww: collation effects sort order and comparison
Munning: Halvors: INSERT INTO tableYouWantToInsertInto possibly, list, of, field, names SELECT list, of, values, and, names FROM tableYouWantToSelectFrom
Demont: Snoyes: the ‘SHOW VARIABLES’ is being processed by the ‘LIKE version’ gets ignored.
Kodish: Is there a collation for German language which strictly adheres to honoring Umlauts? I.e. Ü must match Ü and not U. utf8_bin provides such thing but it’s strictly case sensitive because of binary comparison.
Mccalop: Holodoc: select ‘u’ collate utf8_german2_ci = ‘ü’ collate utf8_german2_ci;
Mccalop: Show collation like ‘%german%’;
Newburn: I am getting an error that “MySQL Server has gone away” one most likely cause of this is the small setting of max_allowed_packet, which was set to something surprisingly small. I checked High Performance MySQL and it says that this value can be set “dangerously large” but it doesn’t actually say what the consequences are. Similarly the MySQL Manual doesn’t tell me anything either.
Velega: Any thoughts and/or ideas.
Leonardis: Kolbe: Interesting. It seems utf8_german2_ci was added with 5.6. Will have to test it though. Thank you!
Mccalop: Holodoc: huh, you’re right. that’s silly P
Isenhower: Kolbe: Yes, working with utf8 collations was a major PITA until now. The existing collations were so bad I had to resort to the default utf8_swedish_ci to run my German related projects.
Bachinski: SJr: “It is safe to increase the value of this variable because the extra memory is allocated only when needed. For example, mysqld allocates more memory only when you issue a long query or when mysqld must return a large result row.”
Bachinski: SJr: https://dev.mysql.com/doc/refman/5.6/en/packet-too-large.html
Bachinski: SJr: you have to set it for client and server. 1GB is the max max
Tannehill: Yeah so I wonder what the book is talking about :
Daubenspeck: Any one know good community to ask for how to use API functions, i have problem with binding string params
Mccalop: Zaherdirkey: what language/API are you using?
Weisel: I made FreePascal, but i can understand c and port it, it is opensource https://sourceforge.net/p/minilib/source/ci/master/tree/connection/db/mysql/
Sandblom: Kolbe my propblem how to change the pointer to PChar of buffer to ***ign new string param, after binding it to statment
Mccalop: Zaherdirkey: “how to change the pointer to PChar of buffer” sounds like it has nearly nothing to do with MySQL and nearly everything to do with how to use the language you’re writing this in, no?
Cokel: Kolbe: it is the same problem even in C
Sliney: Is there a way I can update table names, using information schema, table_names, table_schema, and LIKE?
Kayler: Sliney: Only indirectly.
Bachinski: Xgc: don’t encourage him. :-
Sliney: Bachinski yes! I need to learn how ot use information schema if this is any way to do it I had started to write something, UPDATE INFORMATION_SCHEMA.TABLES SET TABLE_NAME.but not sure if there’s any articles you recommend
Bilyeu: Sliney: You change a table name with alter or drop / create or rename.
Sliney: There’s no way to string it into 1 line I’m ***uming, without concat or group_concat?
Bachinski: Sliney: I believe I told you 3 hours ago the I_S is not directly updateable
Romaniszyn: Sliney: Yuo can not do that. You can only rename a table in the above ways. You can also drop the entire database and recreate it with the correct table names.
Bachinski: Sliney: it’s a virtual database, basically just a view
Sliney: I’m still a noob at this stuff, learning all i can
Hanenkrat: Sliney: See http://dev.mysql.com/doc/refman/5.6/en/alter-table.html
Bachinski: Sliney: be very cautious in changing identifiers like table and column names programmatically.