| Author |
Message |
n3xus
Joined: 06 Mar 2012
Posts: 9
|
|
 Test Data Generator for Oracle issue |
 |
Any how test data generator is generating 3 times longer strings for my Nvarchar2 fields. Is there any known bugs or workarounds?
Or is there anyway I can customize the SqlAssistant query to read table schema?
|
|
| Wed Apr 11, 2012 8:19 am |
  |
 |
n3xus
Joined: 06 Mar 2012
Posts: 9
|
|
| |
|
Well I got it.
I've changed Db Options->DB Queries->Columns script.
replaced "Char_Col_Decl_Length" with "Char_length" and seems working now.
|
|
| Wed Apr 11, 2012 8:29 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7963
|
|
| |
|
Can you tell us if that query in its original form returned incorrect column size values for NVARCHAR and NVARCHAR2 columns displayed in Intellisense prompts? In Table Info view
|
|
| Wed Apr 11, 2012 10:25 am |
|
|
n3xus
Joined: 06 Mar 2012
Posts: 9
|
|
| |
|
 |
|
Can you tell us if that query in its original form returned incorrect column size values for NVARCHAR and NVARCHAR2 columns displayed in Intellisense prompts? In Table Info view |
Yup. It returned incorrect column size on Nvarchar2 fields. I haven't checked it on any other datatypes though.
|
|
| Wed Apr 11, 2012 8:55 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7963
|
|
| |
|
Thank you. In that case your change in "Columns" query is correct, it should work for all SQL Assistant features.
|
|
| Wed Apr 11, 2012 9:59 pm |
|
|
|
