Merge Sort-of Similar Data From 2 Tables In Query
A bit of background. I'm not a web person, and I know enough about databases to scrape by. Most of my SQL is generated using templates or handy things (like PHPMyAdmin etc). I'm also not a PHP coder. I am a C/C++ coder so I've found I can hack some PHP together, and I've got roped into helping a friend with a problem
Here's the issue. I have a MySQL database with 2 tables of interest. Let's call these tables categorydata and itemdata. Both of these tables contain records that describe individual items - the item name, its ID in the system, the date it was added, some free text about it etc.
To be absolutely clear, the purpose of the categorydata table is for a record to define a category (think "puzzles", "board games", "vegetables", whatever), but the record row also includes data on the FIRST item in the category ("banana", "cluedo" etc) along with all its data. The purpose of the itemdata table is to list all the OTHER items in the category ("grapes", "twister" etc). Here's an example record in the categorydata table:
categoryname vegetables
categoryid 1234
categorycreated 10th Jan 2000
categoryowner Bob
firstitemid 4567
firstitemname cucumber
firstitemcreated 12th Jan 2000
firstitemdesc It's long and green
Here's an example record in the itemdata table:
itemid 4568
itemname orange
itemcreated 13th Jan 2000
itemdesc It's round and, er, yeah.
This seems really bad design to me but what do I know.
Here's what I need to do. I need to know how to merge the data in these 2 tables in a single query, ordered by the itemid and firstitemid fields.
In other words, I need the query to merge the data, ordering it so that regardless of the table the record came from the itemids are all in correct numerical order. I need to do this so that I can retrieve each item's data in order.
itemid in the itemsdata table and firstitemid in the categorydata table are unique, so when merged there won't be any colliding ids.
I need to put this in a PHP script (in a loop that dumps out all the items in order), but if someone can just help me with the SQL query syntax I'd appreciate it, I can do the rest.
I think this has something to do with inner joins but I really don't understand how to make it work, or how to retrieve and merge data from 2 tables at once bearing in mind the fields (columns? what do you call them) have different names even though they have the same purpose (ie: firstitemid -v- itemid, firstitemname -v- itemname etc).
View Complete Forum Thread with Replies
Related Forum Messages:
Merge And Sort Data
Hi, I have two (maybe three) tables. In general, they have the same fieldnames. Table A: > ID, title, day, month Table B: > ID, title, day, month, year For Table A data, the year value is the current year: $year = date("Y"); I would like to merge two tables' data and display them sorted according to date.
View Replies !
Pull Similar Data From Two Tables
I need a query to search two seperate tables for similar data and return them in one result. I know you can do multiple select statements in one query but I dont know how to exactly organize them into one result. Does anyone know how to accomplish this.
View Replies !
Querying Two Tables With Similar Data
I have two tables in my database "bannerclicks" and "bannerviews". They list the times a banner is clicked or viewed, respectively. They contain similar data, namely: bannerclicks -------------- id INT clickdate DATE bannerid INT bannerviews -------------- id INT viewdate DATE bannerid INT What would my query be if I wanted to display the months in which ANY activity took place (either a banner was clicked, or a banner viewed)? I've been playing around with queries like this: SELECT DISTINCT MONTH(bannerclicks.clickdate) AS clickmonth, MONTH(bannerviews.viewdate) AS viewmonth FROM bannerclicks, bannerviews WHERE bannerclicks.bannerid=2 AND bannerviews.bannerid=2 ... but it was all no good. In the end I decided to create one table "Banneractivity" with an additional "action" field to contain either "view" or "click". (in retrospect this is a much cleaner approach anyway) But I'm still curious, how would I solve this problem in the future?
View Replies !
Retrieve Data Accross Multiple Similar Tables
I have a number of tables that all have the same table format. I want to query accross all the tables as if they where one large table. I am looking to retrieve data base on one of the columns like: select * from (data_readings.lts4a_line,data_readings.lts12_line,data_readings.lts14_line) where trigger_type='time of day' the error I get is 'column "trigger_type" in where clause is ambiguous' is there a way to do all this in one statment?
View Replies !
Sort Merge On Two Rows
i wanne sort with an conditions SELECT * FROM `message` order by `timeto` condition= `timefrom`>`tijdto` i have 2 tables with numbers and i want them to sort on numbers but take the higest number of thos 2 rows. 6 2 2 5 4 8 must be sorted like 4 8 6 2 2 4 is this possible to take als ways the higest number of to rows to sort on?
View Replies !
Finding Similar Tables
I have developed a site where I can add client profiles with a small amount of information including the project and company info. Each group of company and project information is saved to it's own table with the company name as the table name. I am wondering if there is a way for the code to be able to provide you with the closest existing project in the database. For example if I create a new project with a company that has 50-300 employees (drop down variable), I would like the script to be able to show any other projects with that same characteristic.
View Replies !
Distinct Field From Two Similar Tables
I have two 'similar' tables a) open_works_table b) closed_works_table now, closed_works_table have 2 extra fields compared with open_works_table all other fields are same(name and type). The reason for two similar tables is because open works is quite used and contain only few rows compared to the huge number of closed works(rarely used). I want to get the DISTINCT list of all job_types(a field in both table) from the two tables. How to get it? these two tables are not related, just similar. I think, I can just pass a query SELECT DISTINCT(job_type) FROM {concatenated openworkstable and closedworks table} But how to join two tables one below the other? or is there is some other solution?
View Replies !
Help Needed Merging 2 Different But Similar Tables
Can someone tell me how I can import tables from another non-Joomla mysql file into Joomla? Basically it is just from one mySQL database into another. I use phpMyAdmin to import and export the entire file but I don't know how to do queries. I tried exporting the source database and then renaming all the database names to match the ones I want to merge into but all that happened was a new table was created - no merging. I really just want to select the relevant 3 fields and match them up with the fields in the database table I want to import into. I have an old program that listed all the fields of database 1 in one column and database 2 in another and all I had to do was drag the fields across to make a match and the program did the rest. Perhaps there is a similar one out there? What I am trying to do is import all the articles I have built up using ccTiddlyWiki into Joomla. The only table names of relevance from the source file are: id - title- body IN other words, just the bare essentials. The target files has a table called jos_content with columns: id - title - title_alias - introtext - fulltext in that order and others but are not important. I think it is fairly simple but I am not trained enough. I have 200 items so it would save an enormous amount of time! It seems easy but I don't know enough about queries to do it well. I'm hoping that I can import the articles and then just go through the list in Joomla adding subtitles and so on to conform to Joomla database essentials.
View Replies !
How To Merge Two Or Three Different Tables In One?
I dont know how to merge two or more tables (with it data) into one new. I need to transform my old mysql from my old site into new mysql structure for new site. What I want to do is to transform and copy only user details table from old to new. In old mysql user details are stored into 3 tables with some columns and in new table I have only one table with some columns. That 3 tables have same number of data rows and I array it by ID number. Because I dont need all columns from my user tables from old mysql, I will delete unnecessary columns and leave columns which I need for new table. Now question, how I to merge this three tables to I get only one with certain table structure? Too, I need when merge to copy and all user data which are now stored into that 3 tables and that user data to be merged. Database is MyISAM, table 1, 2 and 3 had some same columns (ID of user and user status) but I delete it from table 2 and 3 because I need only one of it in new table.
View Replies !
Should I Merge Those Tables?
I'm in a bit of dilemma right now. I have a mysql table called `cars` and one called `maintenance`. The table `maintenance` is related to `cars`. Now I want that in the table `maintenance` are always the same rows as in the table `cars`. Not exactly the same rows, but 1 column of `maintenance` is related to 1 column of `cars`. I could also merge those tables, but then the table `cars` would have so many columns. So I thought two separated tables would be more synoptic. What should I do? I already tried to relate those columns with FK-relations with InnoDB, but I don't think that's really the best way.
View Replies !
Query For SIMILAR Terms
does anyone know wether there exists a mySQL syntax that is about the same as e.g. metaphone() or soundex() is in php?So to say that one does a query that gives back all entries that are SIMILAR only? I mean I know the "LIKE" statement, but that gives only back the entries that consist somewhere in the entry of the query word, but I would need more overall-results. Does there exist something else except LIKE - statement?
View Replies !
Comparing Two Tables :: Find Similar Values
I was wondering if there was a SQL command I could use that would find similar values from two specific columns in two different tables.. possibly an intersect? heres what I mean Table 1 blogTitle="I love soccer" Table 2 articleTitle="Soccer is fun" Is there a SQL command that would be able to find the similarities between each column in each different table if, lets say, the user entered "soccer" as a query?
View Replies !
Joining Similar Tables, With NULL At Both Sides
I'm looking for a way to join similar tables. Some columns have the same meaning and should appear as one column in the result, other columns don't and should contain NULL values when they are not applicable. I made a fictional example to make it clear. I have a table 'cars' and a 'bikes', which I would like to join: ......
View Replies !
Merge Tables With Where Clause?
I was wondering if there is a way to create a merge table using where clauses for the underlying tables. I have a date column in all tables and would like to have it so that I could just inset say the last weeks worth of data into the merge or would that be pointless.
View Replies !
Merge Tables And Indexes
if anyone knows if you can index a merge table? Or Will indexing the tables that are members of the merge table improve efficienccy. I actually can make the the indexes on the merge tables, but i'm not sure if tha tis really going to make the indexes and improve performance?
View Replies !
Merge Tables Horizontally
I have tables with the same key. table A. key host data1 1 1 10 2 1 15 3 1 13 table B. key host data1 1 2 25 2 2 27 3 2 22 table C. key host data1 1 3 31 2 3 38 3 3 36 How would I write an sql to merge the data horizontally on key to produce the following output ??: key data1 data1 data1 1 10 25 31 2 15 27 38 3 13 22 36
View Replies !
Merge 3 Tables In Databse Into 1
I have a database with 3 tables: acode, prefix, sufix I would like to combine these 3 into one table: phonenumber , which includes acode+prefix+sufix How can I do this, a detailed explanation would be greatly appreciated as I am a student helping the administration here update their registration page for a competition, and have little experience with php and mysql.
View Replies !
Correct Use Of MERGE Tables?
I have seen general MERGE table usage for logging where a table is created for a fixed period of time, e.g. a month. I am looking to do something different. I currently have a very large table, let's call it emails. There are say a million rows in here. The problem is queries running against this can be slow especially any queries against rows that are not indexed (not all of them can be). What I am thus thinking is to use MERGE tables. Any email that has not been opened in the last year would be moved into an acrhive table. Then what is now the emails table would be renamed so I have emails_archive and emails_current and create the MERGE table emails. Then, any searches would be run on emails_current unless a checkbox was clicked to run on *all* emails. Is this a correct way to use MERGE tables? Is moving rows from emails_current to emails_archive going to be a problem with indexes and unique keys? I believe I can insert rows into the MERGE table and they will by phyiscally put inside emails_current but will check the unique indexes on both the tables.
View Replies !
Merge Data By Number
I am working on a mysql database for a music related project. My question is this: For a medley (ie a song made up of a compilation of songs) how could I merge the track names & numbers, stored in individual fields, to become one field? eg: This: track #................... track name ----------------------------------- 10/1................... Song 1 10/2................... Song 2 10/3................... Song 3 Becomes: track #................... track name ----------------------------------- 10................... Song 1/Song 2/Song 3
View Replies !
Merge Tables Identical Column 1
I have three tables in one database with potential identical rows but different columns (exported from excel, thats the reason). Is it possible to do the following: 1) create a new table with the column headers from each of the three tables automatically (a lot of columns, and a lot of tables in total, to do it by hand would take too long) 2) import the columns from each of the tables into the new table, thereby comparing row1/col1 in table1 with row1/col1 in table2 and, if the are identical, append the data from table 2? Further explanation (to clarify it, hopefully): tab1, tab2 and tab3 should have the same values in their respective row1 (lets call them IDs). only the rest of the columns are different. i want to create a merged table, just appending the columns of table2 to the columns of table1 after checking the ID (the identical values in each table).
View Replies !
How To Group/merge Query
I'm trying to query from a specific column in the table. But there will be repeated values. I wonder if there's any function I can use to "merge" the same ones and end up just a list of all the non-repeating values. Don't know if I make sense here... hope the following helps: Column A -------- apple pear orange apple orange orange cranberry and I want a query that gives me "apple, pear, orange, cranberry" only.
View Replies !
How Would I Merge 2 Colums In A Query
I have 2 colums in a database that I want to merge while calling it. Is this possible? One column type is Integer The other type is Float If column A has a value, column B will be null, and vice versa. Code: Column A | Column B | 1| NULL | NULL| 0.34 | etc.| etc. thanks in advance
View Replies !
How To Stack Tables (maybe Join Maybe Merge)？？？
I have thousands of similar tables which I want to stack one on another. The variables in different tables are almost identical, but not exactly. For example, I have table1 with variables state, month, household id, income where state==1. Also table2 with variables state, month, household id, income where state==2. In addition table2 also has consumption. I want to put table1 and table2 together into one table with variables state, month, household id, income and consumption. Of course for all observations in table1, they get missing values for consumption. I have looked at the command JOIN, but feel it's not what I want. Maybe I misunderstand something. I don't quite understand MERGE, but I really want to get one simple table standing alone.
View Replies !
Get 4 Tables Data In One Query
I am new to mysql relational programming, and creating a tutorial site like pixel2life. I am trying to get the data from 4 tables 1st table is main tutorials table, 2nd is subcategory (subcat) table, 3rd is categories table and 4th is users table. I don't know how to do it exactly, I googled but not got the proper method. I only got some hints http://www.brainbell.com/tutorials/M...ing_A_Join.htm from this site. I've created the following query which selects the title from tutorials table, subcategory (s_cat) from subcat table which reference is available as s_cat_id in tutorials table, then category (cat) from categories table which reference is available in subcategory (subcat) table and username from users table which reference is availble in tutorials table. Can somebody tell me this query is correct or there is any alternate method PHP SELECT d.title, s.s_cat, c.cat, u.username FROM tutorials d JOIN subcat s ON d.s_cat_id=s.id JOIN categories c ON s.cat_id=c.id JOIN users u ON d.author_id=u.id
View Replies !
Query Based On Data Of 3 Tables
this is what I've been trying to implement: I have, say, three tables. One is a user table, with id, username, etc Second is a question table with Question ID, Question, Category etc And third is an "answers" table that keeps answers given by the users. It has the classic id key, and Question id and User Id columns. What I want to do is this: Select a random question of category 1 lets say from the questions table for which user X has no record of answering in the answers table.
View Replies !
Retrieve Data From 2 Tables In 1 Query
I've got 2 tables content & sections I need to: SELECT id, title, section_id , status FROM content and now I'd like to get title from sections WHERE id = section_id from the first part of the query. I've tried with unions but doesn't seem to like it..
View Replies !
Insert Data Into 2 Tables With 1 Query Fails
I found 2 old threads on how to insert data into 2 tables with 1 query. Both of them said that i should seperate the inserts with a ;. But i must be doing something wrong, because it comes up with an error like this ".....right syntax to use near ' INSERT INTO eiland_details" What am i doing wrong? It's possible, right? To insert data into multiple tables with 1 query? $query = " INSERT INTO sub_pages (mainpage_id, intro_text) VALUES ('$main_data->mainpage_id','$sub_intro'); INSERT INTO eiland_details (inwoners, oppervlakte) VALUES ('$detail_inwoners',$detail_oppervlakte')";
View Replies !
Determining Which Table To Query Based On Data Within Tables
I have 2 tables: default_categories column 1: category_id column 2: category_name column 3: category_parent custom_categories column 1: custom_cat_id column 2: custom_cat_name column 3: custom_cat_parent The custom_categories table won't necessarily have anything in it but if it does, I need to choose the data from the custom_categories table over the data from the default_categories table. So if the default category has 3 rows with IDs | names: 123 | Dogs 456 | Cats 789 | Fish And the custom category has 1 row with IDs | names: 456 | Very Cute Cats I want my query of these 2 tables to produce the following IDs | names: 123 | Dogs 456 | Very Cute Cats 789 | Fish I've tried joins like the one below but they aren't working because if there is no custom_cat_id, it won't give me the result for the default category_id. MySQL SELECT * FROM default_categories LEFT JOIN custom_categories ON category_id = custom_cat_id WHERE category_parent = '' AND custom_cat_parent = '' ORDER BY $order_by $sort
View Replies !
How Do I Sort Data Fro A Bad Form Into Something Useful?
I made a bad form with a form creation app in a hurry. Now I have a table that is nearly useless. The form was meant to record teams for an upcoming volleyball tournament. I provided inputs for the school name, mascot, student, etc. The form app allows me to copy form elements, so I did. The table now shows about 120 student, and grade, position, sorted by a form id (one for each team) but they are sorted by the record id. Instead of: Team | Student | Grade | Position | etc..... I have: record | name | value | etc... I have tried some queries that just basically remove some superfluous column and GROUP BY record (that is the form id, so the third team to register has "3" under record. Can I salvage this data by a clever query or am I looking at making a page via php to display the results? Sample Data: student name1 Curtis Geurts student name1Tom Glasbergen student name1Bill Lammers student name1Marc Brouwer student name1Kurt fledderus student name1Nate Brink student name1James Brouwer student name1Scott Denbak student name1Dave Stares grade12 grade12 grade11 grade11 grade11 grade11 grade11 grade12 Player positionpower Player positionsetter Player positionmiddle Player positionmiddle Player positionpower Player positionoffside Player positionsetter Player positionsetter
View Replies !
Sort Data Into Dropdown From Mysql
I have a drop down box that pulls its data from a mysql however I want to orginize my data so that it is a series of headings and sub categories So for example I would have cars ford volvo honda colors red blue yellow My code is so PHP Code: //lets get the categories $getcategories = mysql_query("SELECT * from tbl_category"); while($catrow = mysql_fetch_array($getcategories)) {   extract($catrow); //if category is a parent category make it not selectable if($cat_parent_id =='0'){ echo "<optgroup label='$cat_name'>$cat_name</optgroup>"; }else{ echo "<option>$cat_name</option>"; } }Â
View Replies !
Select Into Outfile Sort Data
i have the following query : (used in visual basic) "select * into outfile ......where id=irand || id=irand2 || id=irand3 || id=irand4 || id=irand5 " the problem is that in the file created the data in sorted ASC, i need the data to output like in the query, irand,irand2,irand3,irand4 and irand5, i see order by 1,2,3,4,5 as a solution but it didnt worked.
View Replies !
Sort A Complex Query
$query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$radio_keyword' IN BOOLEAN MODE) UNION SELECT page.* FROM `page` WHERE MATCH (`title`, `descrip`) AGAINST ('$radio_keyword' IN BOOLEAN MODE) UNION SELECT page.* FROM `page` LEFT JOIN `url_pages` USING (`page_id`) WHERE MATCH (`url_pages`.`page_url`) AGAINST ('$radio_keyword' IN BOOLEAN MODE)"; How do I ORDER BY `page`.`title` for the entire query? ie. I want to get the whole query sorted by the page.title field, but I don't see a way to slap on an "ORDER BY" on the whole query.
View Replies !
Random Sort Query
$querystring = $querystring." ORDER BY status, dateposted desc"; How can i make my query that its sorts first by status and then random for date posted.
View Replies !
Sort MySQL Data By Field In Second Table
I've got a table, 'Events', with a series of fields, one of which is 'CompanyID'. This is an integer that refers to another table, 'Company', which is a list of IDs and companies. Now, is it possible to select from the first table of 'Events' and sort the data by the company name in 'Company' referred to by the 'CompanyID'?
View Replies !
Select Query Sort Order
Example DB: Orders Table Order ID, Date, WeekID, Amount 1, 5/10/08, 0, 100.00 2, 9/3/08, 0, 200.00 3, 0/0/00, 1, 150.00 Weeks Table WeekID, DueDate 1, 7/2/08 I need the output to be in the following order base off of date ASC OrderID Date Amount 1 5/10/08 100.00 3 7/2/08 150.00 2 9/3/08 200.00
View Replies !
Random Query, How To Keep Sort Order Locked?
PHP Version 5.1.6 - mySQL 5.0.22 Let's pretend we have 100.000 rows in a table (all containing images with details), and I want to display 100 images at a single frontend page, but randomly retrieved and keeping the sort order once initiated to a user session. With the normal RAND function, you have a chance to stumble on the same images when you navigate to the next page with again 100 items on. But even worse, going back to page 1, will return totally different results, and will freak out the viewer How to get a (fake) random listing on a fairly large database, where every requested row is unique, and the sort order is being locked (until you press a randomize button ie, or start a new session) while keeping speed in mind (so trying to avoid reading out all rows up front).
View Replies !
SQL Query Problems (for Use With A Sort Of Live Search)
I created some code that loaded information from an XML file, but many thanks to jimfraser on here I'm working on a solution that'll drag it directly from the database. Problem is, it's not displaying anything at all, so I assume there's a problem with the SQL query or the way it's being presented on the page. PHP <?php $network = new COM("WScript.Network"); include_once('../../../functions/datalib.php'); $db = new oracleClass(); $conn = $db->connect(); //get the q parameter from URL $q=$_GET["q"]; //lookup all links from the xml file if length of q>0 if (strlen($q) > 0) { $hint=""; // connect to the database $sqlstatement = 'select * from TEST."WFO_REPORTS_ALLEMPS" order by "Surname", "Forenames"' $sqlListings = OCI_Parse($conn, $sqlstatement); OCI_Execute($sqlListings); while(OCI_Fetch($sqlListings)) { $name = oci_result($sqlListings, "Forenames") . ($sqlListings, "Surname") //find a link matching the search text if (strchr($name,$q)) { if ($hint != "") { $hint .= "<br />"; } $hint .= "<a href='#' onclick='employee_form.Line_Manager_Staff_No.value=" . oci_result($sqlListings, "Gc_Staff_Number") . ";checknumber('Line_Manager_Staff_No','displayusername');'>" . oci_result($sqlListings, "Surname") . ", " . oci_result($sqlListings, "Forenames") . "</a>"; } } } // Set output to "no suggestion" if no hint were found if ($hint == "") { $response="No user found."; } else { $response=$hint; } //output the response echo $response; ?> On a side note, is there a way I can change it so that the search will present any users based on their first name, as well as the surname?
View Replies !
Sort With Limit But Sort ALL Results.
I have a query that limits by 50 results at a time and I also have an order on a int field. The issue I'm having is it's only ordering by the 50 it returns, how can I have it order by the entire results set and then give me back only 50 results?
View Replies !
Similar To IN
okay so like, if i do blah blah blah IN ('x','y','z') more blah i get results if any of the 3 values x,y or z match, right? so is there an easier way to return data from somewhere, only when all 3 match, sort of like that IN statement, like... blah blah blah ONLY IN ('x','y','z') more blah ? or do i have to do all 3 individually like where blah = blah AND blah = blah AND blah = blah ?
View Replies !
Most Similar
I am working on a PHP script, and I want it so it searches a database for something (such as "MySQL is very fun to use"). Now I want it so that if there was no result called "MySQL is very fun to use", then it searches for the most similar entry (such as "MySQL is fun to use" or MySQL is easy to use".) Is that at all possible, and if it is, may somebody explain it to me, or point me to a place that does? Also I understand basic MySQL (how to do searches, and other simple stuff like that). Also if this isn't possible, is there any way to reverse wild card (wild card the results instead of the search). This would mean that if you searched for "MySQL is fun and easy to use", then "MySQL is fun" could show up.
View Replies !
Similar Entries
What is the best way to find similar entries? If I have some data like "What processor company is Apple going to be using in the future? Intel." I then want to be able to scan other entries with other data and find entries that are similar. One way would be to take words greater than 3 letters and then try to find those, but I'm not quite sure how to do it.
View Replies !
Similar Names
I'm trying to retrieve a list of similar customer names from a database table (e.g. Inca, Inca Ltd and Inca 12 etc). I've created a new table called 'dups' with all 20000 cust names but with the last 4 characters removed from each. I've tried the statement below but obviously this isn't correct. Anyone with any ideas? SELECT c.cust_name FROM customer c, dups d WHERE c.cust_name LIKE "(d.cust_name)%";
View Replies !
Two Similar Fields One Table
I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123" Field2="testing" I need something that selects that row because the word "testing" is in both.
View Replies !
Count Columns With Similar Name
I have a table that has several columns named media1, media2, etc all the way to media10. What I'm trying to do is count how many of those media* columns in a specific row defined by a primary key (tutID) aren't NULL and return the integer.
View Replies !
How To Set Similar Character Set In Ad And Mysql
I am connecting users from AD to Sun Identity Manager (IDM), and the IDM uses MySQL. The strange thing is that Norwegian characters keep showing up as ? or other strange characters like a Y with double line over or A with ~ on top and some other character next to it... We have set the character set to utf8 and collation to utf8_bin, but we get the same strange characters as we are when running latin1. AD is running a character set called ISO-10646 (similar til unicode), and our theory is that it might be a conflict with the character sets between the different resources. Anyone had similiar problems?
View Replies !
|
TRACKER
