Example #1
0
        private void SetFieldEncoding()
        {
            Dictionary <int, string> characterSets = this.driver.CharacterSets;
            DBVersion version = this.driver.Version;

            if (characterSets == null || characterSets.Count == 0 || this.CharacterSetIndex == -1)
            {
                return;
            }
            if (characterSets[this.CharacterSetIndex] == null)
            {
                return;
            }
            CharacterSet characterSet = CharSetMap.GetCharacterSet(version, characterSets[this.CharacterSetIndex]);

            if (characterSet.name.ToLower(CultureInfo.InvariantCulture) == "utf-8" && version.Major >= 6)
            {
                this.MaxLength = 4;
            }
            else
            {
                this.MaxLength = characterSet.byteCount;
            }
            this.Encoding = CharSetMap.GetEncoding(version, characterSets[this.CharacterSetIndex]);
        }
Example #2
0
        private void SetFieldEncoding()
        {
            Dictionary <int, string> charSets = driver.CharacterSets;
            DBVersion version = driver.Version;

            if (charSets == null || charSets.Count == 0 || CharacterSetIndex == -1)
            {
                return;
            }
            if (charSets[CharacterSetIndex] == null)
            {
                return;
            }

            CharacterSet cs = CharSetMap.GetCharacterSet(version, (string)charSets[CharacterSetIndex]);

            // starting with 6.0.4 utf8 has a maxlen of 4 instead of 3.  The old
            // 3 byte utf8 is utf8mb3
            if (cs.name.ToLowerInvariant() == "utf-8" &&
                version.Major >= 6)
            {
                MaxLength = 4;
            }
            else
            {
                MaxLength = cs.byteCount;
            }
            Encoding = CharSetMap.GetEncoding(version, (string)charSets[CharacterSetIndex]);
        }
Example #3
0
        private void SetFieldEncoding()
        {
            Hashtable charSets = driver.CharacterSets;
            DBVersion version  = driver.Version;

            if (charSets == null || CharacterSetIndex == -1)
            {
                return;
            }
            if (charSets[CharacterSetIndex] == null)
            {
                return;
            }

            CharacterSet cs = CharSetMap.GetCharacterSet(version, (string)charSets[CharacterSetIndex]);

            // starting with 6.0.4 utf8 has a maxlen of 4 instead of 3.  The old
            // 3 byte utf8 is utf8mb3
            if (cs.name.ToLower(System.Globalization.CultureInfo.InvariantCulture) == "utf-8" &&
                version.Major >= 6)
            {
                MaxLength = 4;
            }
            else
            {
                MaxLength = cs.byteCount;
            }
            Encoding = CharSetMap.GetEncoding(version, (string)charSets[CharacterSetIndex]);
        }
Example #4
0
        private MySqlField GetFieldMetaData41()
        {
            MySqlField field = new MySqlField(connection);

            stream.OpenPacket();
            field.Encoding           = encoding;
            field.CatalogName        = stream.ReadLenString();
            field.DatabaseName       = stream.ReadLenString();
            field.TableName          = stream.ReadLenString();
            field.RealTableName      = stream.ReadLenString();
            field.ColumnName         = stream.ReadLenString();
            field.OriginalColumnName = stream.ReadLenString();
            stream.ReadByte();
            field.CharacterSetIndex = stream.ReadInteger(2);
            field.ColumnLength      = stream.ReadInteger(4);
            MySqlDbType type = (MySqlDbType)stream.ReadByte();
            ColumnFlags colFlags;

            if ((Flags & ClientFlags.LONG_FLAG) != 0)
            {
                colFlags = (ColumnFlags)stream.ReadInteger(2);
            }
            else
            {
                colFlags = (ColumnFlags)stream.ReadByte();
            }

            field.SetTypeAndFlags(type, colFlags);

            field.Scale = (byte)stream.ReadByte();


            if (stream.HasMoreData)
            {
                stream.ReadInteger(2); // reserved
            }

            if (charSets != null && field.CharacterSetIndex != -1)
            {
                CharacterSet cs = CharSetMap.GetCharacterSet(Version, (string)charSets[field.CharacterSetIndex]);
                // starting with 6.0.4 utf8 has a maxlen of 4 instead of 3.  The old
                // 3 byte utf8 is utf8mb3
                if (cs.name.ToLower(System.Globalization.CultureInfo.InvariantCulture) == "utf-8" &&
                    Version.Major >= 6)
                {
                    field.MaxLength = 4;
                }
                else
                {
                    field.MaxLength = cs.byteCount;
                }
                field.Encoding = CharSetMap.GetEncoding(version, (string)charSets[field.CharacterSetIndex]);
            }

            return(field);
        }
        public static CharacterSet GetCharacterSet(DBVersion version, string CharSetName)
        {
            CharacterSet cs = (CharacterSet)mapping[CharSetName];

            if (cs == null)
            {
                throw new MySqlException("Character set '" + CharSetName + "' is not supported");
            }
            return(cs);
        }
 /// <summary>
 /// Returns the text encoding for a given MySQL character set name
 /// </summary>
 /// <param name="version">Version of the connection requesting the encoding</param>
 /// <param name="CharSetName">Name of the character set to get the encoding for</param>
 /// <returns>Encoding object for the given character set name</returns>
 public static Encoding GetEncoding(DBVersion version, string CharSetName)
 {
     try
     {
         CharacterSet cs = GetCharacterSet(version, CharSetName);
         return(Encoding.GetEncoding(cs.name));
     }
     catch (NotSupportedException)
     {
         return(Encoding.GetEncoding("utf-8"));
     }
 }
        public static CharacterSet GetCharacterSet(DBVersion version, string CharSetName)
        {
            CharacterSet characterSet = null;

            if (CharSetMap.mapping.ContainsKey(CharSetName))
            {
                characterSet = CharSetMap.mapping[CharSetName];
            }
            if (characterSet == null)
            {
                throw new MySqlException("Character set '" + CharSetName + "' is not supported by .Net Framework.");
            }
            return(characterSet);
        }
Example #8
0
        public static Encoding GetEncoding(DBVersion version, string CharSetName)
        {
            Encoding encoding;

            try
            {
                CharacterSet characterSet = CharSetMap.GetCharacterSet(version, CharSetName);
                encoding = Encoding.GetEncoding(characterSet.name);
            }
            catch (NotSupportedException)
            {
                encoding = Encoding.GetEncoding("utf-8");
            }
            return(encoding);
        }
Example #9
0
        private MySqlField GetFieldMetaData41()
        {
            MySqlField field = new MySqlField(this.connection);

            stream.OpenPacket();
            field.Encoding           = encoding;
            field.CatalogName        = stream.ReadLenString();
            field.DatabaseName       = stream.ReadLenString();
            field.TableName          = stream.ReadLenString();
            field.RealTableName      = stream.ReadLenString();
            field.ColumnName         = stream.ReadLenString();
            field.OriginalColumnName = stream.ReadLenString();
            byte b = (byte)stream.ReadByte();

            field.CharacterSetIndex = stream.ReadInteger(2);
            field.ColumnLength      = stream.ReadInteger(4);
            MySqlDbType type = (MySqlDbType)stream.ReadByte();
            ColumnFlags colFlags;

            if ((Flags & ClientFlags.LONG_FLAG) != 0)
            {
                colFlags = (ColumnFlags)stream.ReadInteger(2);
            }
            else
            {
                colFlags = (ColumnFlags)stream.ReadByte();
            }

            field.SetTypeAndFlags(type, colFlags);

            field.Scale = (byte)stream.ReadByte();


            if (stream.HasMoreData)
            {
                int reserved = stream.ReadInteger(2);   // reserved
            }

            if (charSets != null)
            {
                CharacterSet cs = CharSetMap.GetChararcterSet(this.Version, (string)charSets[field.CharacterSetIndex]);
                field.MaxLength = cs.byteCount;
                field.Encoding  = CharSetMap.GetEncoding(this.version, (string)charSets[field.CharacterSetIndex]);
            }

            return(field);
        }
Example #10
0
        public static CharacterSet GetCharacterSet(DBVersion version, string charSetName)
        {
            if (charSetName == null)
            {
                throw new ArgumentNullException("CharSetName is null");
            }
            CharacterSet cs = null;

            if (_mapping.ContainsKey(charSetName))
            {
                cs = _mapping[charSetName];
            }

            if (cs == null)
            {
                throw new NotSupportedException("Character set '" + charSetName + "' is not supported by .Net Framework.");
            }
            return(cs);
        }
Example #11
0
        private void SetFieldEncoding()
        {
            Dictionary <int, string> charSets = driver.CharacterSets;
            DBVersion version = driver.Version;

            if (charSets == null || charSets.Count == 0 || CharacterSetIndex == -1)
            {
                return;
            }
            if (charSets[CharacterSetIndex] == null)
            {
                return;
            }

            CharacterSet cs = CharSetMap.GetCharacterSet(version, (string)charSets[CharacterSetIndex]);

            MaxLength = cs.byteCount;
            Encoding  = CharSetMap.GetEncoding(version, (string)charSets[CharacterSetIndex]);
        }
Example #12
0
        /// <summary>
        /// Returns the text encoding for a given MySQL character set name
        /// </summary>
        /// <param name="version">Version of the connection requesting the encoding</param>
        /// <param name="charSetName">Name of the character set to get the encoding for</param>
        /// <returns>Encoding object for the given character set name</returns>
        public static Encoding GetEncoding(DBVersion version, string charSetName)
        {
            try
            {
                CharacterSet cs = GetCharacterSet(version, charSetName);

                Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);

                return(Encoding.GetEncoding(cs.name));
            }
            catch (ArgumentException)
            {
                return(Encoding.GetEncoding("utf-8"));
            }
            catch (NotSupportedException)
            {
                return(Encoding.GetEncoding("utf-8"));
            }
        }
Example #13
0
        private MySqlField GetFieldMetaData41()
        {
            MySqlField mySqlField = new MySqlField(base.Version);

            this.reader.OpenPacket();
            mySqlField.Encoding           = this.encoding;
            mySqlField.CatalogName        = this.reader.ReadLenString();
            mySqlField.DatabaseName       = this.reader.ReadLenString();
            mySqlField.TableName          = this.reader.ReadLenString();
            mySqlField.RealTableName      = this.reader.ReadLenString();
            mySqlField.ColumnName         = this.reader.ReadLenString();
            mySqlField.OriginalColumnName = this.reader.ReadLenString();
            this.reader.ReadByte();
            mySqlField.CharacterSetIndex = this.reader.ReadInteger(2);
            mySqlField.ColumnLength      = this.reader.ReadInteger(4);
            MySqlDbType type = (MySqlDbType)this.reader.ReadByte();
            ColumnFlags flags;

            if ((this.Flags & ClientFlags.LONG_FLAG) != (ClientFlags)0)
            {
                flags = (ColumnFlags)this.reader.ReadInteger(2);
            }
            else
            {
                flags = (ColumnFlags)this.reader.ReadByte();
            }
            mySqlField.SetTypeAndFlags(type, flags);
            mySqlField.Scale = (byte)this.reader.ReadByte();
            if (this.charSets != null)
            {
                CharacterSet chararcterSet = CharSetMap.GetChararcterSet(base.Version, (string)this.charSets[mySqlField.CharacterSetIndex]);
                mySqlField.MaxLength = chararcterSet.byteCount;
                mySqlField.Encoding  = CharSetMap.GetEncoding(this.version, (string)this.charSets[mySqlField.CharacterSetIndex]);
            }
            return(mySqlField);
        }