This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
| Summary: | I18N - MySQL isn't installed correctly for work in non-english locale | ||
|---|---|---|---|
| Product: | installer | Reporter: | Roman Mostyka <romanmostyka> |
| Component: | Code | Assignee: | dlipin <dlipin> |
| Status: | VERIFIED FIXED | ||
| Severity: | blocker | CC: | kaa, kfrank |
| Priority: | P3 | Keywords: | I18N |
| Version: | 6.x | ||
| Hardware: | All | ||
| OS: | Windows XP | ||
| Issue Type: | DEFECT | Exception Reporter: | |
| Attachments: |
ide.log
mysql_config.log mysql_install.log |
||
|
Description
Roman Mostyka
2008-07-22 15:56:49 UTC
Hopefully fixed. http://hg.netbeans.org/main/rev/38327518118c Unfortunately this bundle is not built on regular basis so I would explicitely ask to verify the issue when we start working on NetBeans6.5/MySQL bundle. Dmitry Andrey, please verify this issue with future build. the issue is reproducible with the following environment: Product Version: NetBeans IDE Dev (Build 200807221016) Java: 1.6.0_06; Java HotSpot(TM) Client VM 10.0-b22 System: Windows XP version 5.1 running on x86; MS932; ja_JP (nb) Userdir: U:\tmp\0722_001 ftp://neoopal.russia.sun.com/Temp/dlipin/netbeans-trunk-nightly-200807221016-mysql-windows.exe Roman, could you please give more info on this issue? > Then Andrei Badea suggest to check if mysql driver return this table. With simple code we checked that it doesn't and > therefore such tables aren't visible in DB Explorer. So the problem is that driver "don't see" such tables and this is > not NetBEans problem, but rather MySQL and installer. MySQL driver is included in the NetBeans itself and installer does not control that. > Then I installed latest stable mysql build was it 5.0.51b or 5.1.26rc? > and set for it utf8 enconding (not latin1, which is default) and with this > installation everything works fine for me. I'm able now to create tables with non-ascii symbols in a name. If NetBeans is the same (and this mysql driver is the same) then it might be the MySQL server issue. > So therefore this issue doesn't exist for me anymore, because it was fixed by setup of mysql and I closed this issue > and open new one for installer, since customer should be able to install what is necessary and then just work and arised problem is issue of mysql setup. As Andrey checked, the setting default charset does not fix the issue, then likely the issue is in the other area... Result of another experiment: I'm running in Japanese locale, using a pseudo localized Netbeans with font size 16 option. Product Version: NetBeans IDE Dev (Build 20080721233246) Java: 1.6.0_06; Java HotSpot(TM) Client VM 10.0-b22 System: Windows XP version 5.1 running on x86; MS932; ja_JP (nb) 1. I installed MySQL separately using mysql-essential-5.0.51b-win32.msi 2. Connected to the test database 3. Executed the following statement: "create table `quo+ted` (`i-d` int primary key );" 4. Invoked Refresh action from the pop-up menu on tables node The table quo+ted appears under the "Tables" node. I think the problem is in drivers bundled with NetBeans. I meant the problem isn't in driver since NetBeans used bundled one to connect to the external server. Probably bundled server was not properly configured during the installation. Andrey and Roman and Dmitry, could it be that the problem here is 128729 and its not about installer actions, even though installer now sets server view of dbase encoding ? (btw, should the installer be setting this value anyway since user might not want it, but I guess perhaps it does not matter, since its set to something, and I think assumption is that user would need to change it in any case. ? about drivers, is the one provided in ide9/modules/ext just the standard and released one from mysql ? ken.frank@sun.com Dima, I installed 5.1.26rc build and during installation set utf8 encoding and with this everything works fine. But Andrey installed MySQL and doesn't change anything and everything works fine for him also. So or installer changed encoding for Andrey by itself (because Andrey works in Japan locale) or installer changed some other settings and fact that I changed enconding doesn't mean anything (and probably everything should work fine without this change). I uninstall standalone MySQL and then reinstall it again, but set default enconding to latin1, but anyway with standalone MySQL server everything works fine, I see created table `quo+ted`. But I work in Russian locale, not in Japan. So probably the reason not the encoding. I`ve rebuild MySQL bundle with 5.0.51b. ftp://neoopal.russia.sun.com/Temp/dlipin/netbeans-trunk-nightly-200807221016-mysql-51b-windows.exe I`ve installed it with all default settings except the installdirs - I`ve used C:\Sun\... instead of C:\Program Files \... I could succesfully reproduce the scenario that Andrey tried: 1. Connected to the test database 2. Executed the following statement: "create table `quo+ted` (`i-d` int primary key );" 3. Invoked Refresh action from the pop-up menu on tables node 4. The table quo+ted appears under the "Tables" node. Product Version: NetBeans IDE Dev (Build 200807221016) Java: 1.6.0_10-beta; Java HotSpot(TM) Client VM 11.0-b11 System: Windows XP version 5.1 running on x86; MS932; ja_JP (nb) Userdir: C:\Documents and Settings\dl198388\.netbeans\dev I again tried to do the same with netbeans-trunk-nightly-200807221016-mysql-windows.exe (5.0.51a) - and it works. So I can`t reproduce the problem with both 5.0.51a and 5.0.51b (both installed with utf8 charset). I tried to install the released NetBeans 6.1/MySQL bundle in the same environment (but latin1 charset). The result is the same - it works fine. Andrey, could you please attach the latest installation logs, the correspond to the environment where the issue is reproducible? I`m interested in logs from ~/.nbi/log (including *_mysql_config.log and *_mysql_install.log). any other ideas? its a long issue and wanted to see if could get summary of it - some questions a. is it really a problem ? seems like user would need to configure mysql in any case to work in some encoding they would want (I don't think this is about locales but about encoding ?) and i think mysql defaults to using latin1 for encoding, even of server, until changed ? or does it, when installing standalone or standalone setup, use encoding of locale user is in ? b. I can see using utf-8 is ok since it is more common now but we can't assume that it would be what is wanted in every case same that latin encoding would not be wanted in any case. c. thus having a restatement of the problem would help (me at least) get the current picture of this. could this be restated and summarized ? ken.frank@sun.com Product Version: NetBeans IDE Dev (Build 200807221016) Java: 1.6.0_06; Java HotSpot(TM) Client VM 10.0-b22 System: Windows XP version 5.1 running on x86; MS932; ja_JP (nb) Userdir: U:\tmp\0722_003 I took the following bundle netbeans-trunk-nightly-200807221016-mysql-51b-windows.exe The issue is not reproducible there. If all changes will be merged in the official mysql bundle then I think its ok to verify the issue. Created attachment 65660 [details]
ide.log
Created attachment 65661 [details]
mysql_config.log
Created attachment 65662 [details]
mysql_install.log
yes, it will be used in the official mysql bundle. v. |