https://bugs.documentfoundation.org/show_bug.cgi?id=68426
--- Comment #16 from LinnDa <[email protected]> --- > (Testing Bugzilla re: Total # of characters... perhaps it doesn't like SQL?) > > With my shiny new 64bit OSX build of LO master : > > Version: 4.2.0.0.alpha0+ > Build ID: https://myteamz.co.uk/linnworks/ > > I can connect to a registered ODBC datasource, and see the tables listed > when I click the Tables icon in the main base window. > > However, if I double click on any table entry, I get the following error > message : > > The data content could not be loaded. > Syntax error in SQL statement. > > SQL Status: HY000 > Error code: 1000 > > Syntax error in SQL statement > > SQL Status: HY000 > Error code: 1000 > > XXXXXX X XXXX X > > Lorem Ipsum Dolor Set (...or something, I don't remember how that goes! :P ) > > Another few lines of text here > should be enough to tell > if the problem exists in total number of chars > or if it's just biased against SQL... It looks like the table name is given in UTF-16, but that is not the encoding that MySQL expects. It works for me on Debian GNU/Linux amd64 (64 bits). However, I can reproduce something similar with table names containing non-ascii characters if the setting "Character set" is set to something wrong. Could you check this setting (edit / database / properties / Additional settings)? -- You are receiving this mail because: You are the assignee for the bug.
