Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Oracle varchar in remote view
The back end database used by the company I work is Oracle. They use VARCHARs extensively. I am going to be migrating all of my tables into the existing schema. We are basically mergin a number of products into one larger configurable product suite. But remote views only let me choose CHAR and from what I have seen so far the data is padded with spaces to the length of the field.
For instance I had a generated key table that has a 2 fields.
FIELDID CHAR(8)
LASTUSED CHAR(20)
I moved the table into ORACLE using varchars. Previously he parameterized view worked when given an unpadded parameter. But when moved to oracle I had to pad the parameter with spaces for it to work.
Does anyone have any suggestions?
The other developpers want me to find a way to remove the extra padding that is sent to the VARCHARs.
Any ideas?
Jason
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement