vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   charset problem while migrating from mssql (https://vborg.vbsupport.ru/showthread.php?t=196083)

hctopcu 11-12-2008 02:36 PM

charset problem while migrating from mssql
 
I'm trying to migrate to vBulletin from an old version of maxportalweb.
Forum is Turkish and db is mssql uses latin1.
Impex system does not support mssql. So I had to first convert database to mysql then try to import them.
Because migration tool failed, I transfered db as utf-8 on another software. (Not have another encoding option)

I can see the data correctly while using selects on query analyser.
But when I try insert-select or use working modules of impex system I get "?"s in my language specific characters.
I tried migration tool to convert to latin1, it failed.
I tried CONVERT(... using latin1) in query, nothing changed.

snakes1100 11-12-2008 03:01 PM

Impex is a software that is supported at vbulletin.com, i would issue a support ticket there.

hctopcu 11-12-2008 03:30 PM

I know but they already said impex does not support maxportalweb on mssql.
The maxportalweb module of impex is not fully functional even on mysql. I am half using impex half writing queries on query analyser. :(
And this is not their problem.
I have a utf8 database derived from mssql. If I ask I'm quite sure the answer will be: "Your database is corrupted impex needs intact data..."

SEOvB 11-12-2008 07:46 PM

Your database is corrupted impex needs intact data


All times are GMT. The time now is 09:17 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02165 seconds
  • Memory Usage 1,707KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete