linking oracle tables in access [message #243138] |
Wed, 06 June 2007 04:02  |
Geiri
Messages: 3 Registered: June 2007 Location: Iceland
|
Junior Member |
|
|
Hello
I use access to select and update data both in access databases and in a Oracle db (version 8 )
I'm having some problems update-ing a varchar2(4000) field in oracle. When the length of the text being put in the field goes over 2000 characters access/oracle truncates the string down to 2000 characters.
Here is my code:
UPDATE AL_TRYGGTEGUMSOKN SET AL_TRYGGTEGUMSOKN.MINNISP = [MINNISP] & ' text to be added'
WHERE AL_TRYGGTEGUMSOKN.ID=373896;
The data in the field MINNISP did not change because its length was allready 2000.
I'm guessing its being converted to datatype char which maximum length is 2000.
Can you help me with this problem?
Best regards, Asgeir Gudbjartsson
[Updated on: Wed, 06 June 2007 04:02] Report message to a moderator
|
|
|
|
Re: linking oracle tables in access [message #243143 is a reply to message #243141] |
Wed, 06 June 2007 04:11   |
Geiri
Messages: 3 Registered: June 2007 Location: Iceland
|
Junior Member |
|
|
What is the datatype of column MINNISP?
The table is in oracle and there MINNISP is of the type varchar2(4000) but when linking the table in access its type becomes Memo when viewed in access.
What is its character set?
Where can I see this property?
Thank you for answering, Geiri
|
|
|
|
Re: linking oracle tables in access [message #243147 is a reply to message #243145] |
Wed, 06 June 2007 04:24  |
Geiri
Messages: 3 Registered: June 2007 Location: Iceland
|
Junior Member |
|
|
Here is the charactersets
--(Ordinary) character set
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
WE8MSWIN1252
--National character set
select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';
AL16UTF16
|
|
|