Re: [h2] Migration from 1.4.199 TO 2.1.210 Character Problem
Ah, thank you, it's a really old database, so it worked until now. I will modifiy the sql dump and test it. Noel Grandin schrieb am Mittwoch, 30. März 2022 um 11:07:46 UTC+2: > CHAR has a default length of 1 and is a fixed length datatype. > I think you want to be using VARCHAR there. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6250d079-e4fc-4209-9601-8ccd344a8f22n%40googlegroups.com.
Re: [h2] Migration from 1.4.199 TO 2.1.210 Character Problem
CHAR has a default length of 1 and is a fixed length datatype. I think you want to be using VARCHAR there. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAFYHVnUSn_dVb0g9wHhM65FvBGFigvq88BtasqAD920N62rLCw%40mail.gmail.com.
[h2] Migration from 1.4.199 TO 2.1.210 Character Problem
Hello, When I try to migrate from 1.4.199 to 2.1.210 via SCRIPT / RUNSCRIPT, I get an error message: Value to long for coulmn "NAME CHARACTER". "Customer Name with 33 characters ", (33). The create statement in the script file is: CREATE CACHED TABLE "PUBLIC"."CUSTOMERS"( "CUSTOMERID" INT NOT NULL SELECTIVITY 100, "NAME" CHAR SELECTIVITY 93, "STREET" CHAR SELECTIVITY 88, "NUMBER" CHAR SELECTIVITY 46, "COUNTRY" CHAR SELECTIVITY 2, "PLZ" CHAR SELECTIVITY 77, "CITY" CHAR SELECTIVITY 67, "OLD" DATETIME DEFAULT NULL SELECTIVITY 4 ); So, what I'm doing wrong? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/2d8269d6-6009-4691-999e-11ac3b4627ddn%40googlegroups.com.
