Notes 4 for Oracle Problems

Today, the blog of the 8-language version is intended to support Oracle, so there are a bunch of problems and summary:

 

1: how to retrieve the table from MSSQL and construct it to Oracle? I used the data export function and encountered the following problems:

 

A: When I test the database connection, there is A [remember Password]. Sun, I didn't check it at first. The test link was successful, but an error was prompted in the next step.

Solution: Tick the Remember password. Relying on ~~~ Sun.

 

 

B: Table data type problem: the default nvarchar (n) statement is written as nvarchar2. The long field length must be added to nvarchar (length)

Solution: change the length of multiple fields one by one. Relying on ~~~ Sun

 

 

C: The table name and field name are incorrect. By default, double quotation marks (") are added, and" "can be used in Oracle with lower-case letters. The result is that no data can be found in the database.

Solution: Remove all double quotation marks during generation. Select * from "Users", and add "" to the table name. Relying on ~~~ Sun

 

 

D: Oracle keyword, sun. Why are there so many keywords? Some tables conflict with some fields and keywords, and double quotation marks are not allowed. This is the sun.

Solution: to be compatible with multiple databases, add a prefix to the table.

 

 

Finally, we decided not to support Oracle, so we didn't have much energy ~~